FTP Configuration

Purpose: CWSerenade uses FTP (File Transfer Protocol) to transmit files from one server to another.

• Delivered FTP Applications

• FTP Configuration File

• Creating Your Own FTP Applications

• FTP Troubleshooting

Delivered FTP Applications

Use the Working with FTP Applications (WFTP) menu option to work with FTP applications. You can use this menu option to create, change, or delete an FTP application, process the FTP commands for an FTP application, and review the FTP log for an FTP application.

CWSerenade is delivered with FTP applications pre-defined with FTP commands used for the CWCollaborate integration. However, you can modify the delivered FTP applications to fit your own needs; see Creating Your Own FTP Applications.

Note: FTP is not used as part of the integration with Locate’s Drop Ship Manager module.

Required setup: Before you can use the delivered FTP applications, you must use the Change FTP Application screen to define the IP address of the remote server and the user ID and password used to connect to the remote server via FTP. For example, if you are using the CWCollaborate integration, you must define the IP address of the CWCollaborate server and the user ID and password used to connect to the CWCollaborate server via FTP. See Work with FTP Application Screen for field descriptions.

See the CWCollaborate Configuration and Reference Guide for more information on how information received from CWSerenade is processed once it reaches the CWCollaborate server.

• C01- Send Vendors FTP Application

• C02 - Send Purchase Orders FTP Application

• C03 - Send Cancel Requests FTP Application

• C04 - Send Return Authorizations FTP Application

• C05 - Send RA Cancels FTP Application

• C06 - Send Cost Changes FTP Application

• C07 - Receive PO Updates FTP Application

• C08 - Receive RA Updates FTP Application

• C09 - Receive AP Updates FTP Application

• C10 - Outbound PO Changes FTP Application

Note: The FTP application code you define in each CDC FTP ID system control value must be the same FTP application code used for all companies in a single environment. For example, the FTP application code you enter in the CDC FTP ID for Cancellation Requests (H18) system control value must be populated with the same FTP application code for all companies in the environment.

C01- Send Vendors FTP Application

Use this FTP application to send vendor information from the CSF Vendor Download Table (FLCSVD) in the CWSerenade database to the vendor file in the oms\Serenade\inbox directory on the CWCollaborate server.

Enter this FTP application code in the CDC FTP ID for Vendor Download (H16) system control value.

FTP command:

Seq	FTP Command	Local File	Remote File	Remote Directory
001	PUT	FLCSVD	vendor	oms\Serenade\inbox

This FTP command:

• Pulls vendor information from the CSF Vendor Download table (FLCSVD) in the CWSerenade database.

• Creates a flat file named vendor on the CWSerenade application server in the local directory defined in the CWDIRECTCP_FTP_FOLDER setting in the CWDirectCP Properties file. The delivered directory is C:\\CWSerenade\\FTP.

• Transmits the vendor flat file from the local FTP directory on the CWSerenade application server to the oms\Serenade\inbox directory on the CWCollaborate server.

C02 - Send Purchase Orders FTP Application

Use this FTP application to send new purchase order information from the CSF PO Download Table (FLCSPO) in the CWSerenade database to the newpo file in the oms\Serenade\inbox directory on the CWCollaborate server.

Enter this FTP application code in the CDC FTP ID for PO Download - New (H17) system control value.

FTP command:

Seq	FTP Command	Local File	Remote File	Remote Directory
001	APPEND	FLCSPO	newpo	oms\Serenade\inbox

This FTP command:

• Pulls purchase order information from the CSF PO Download table (FLCSPO) in the CWSerenade database.

• Creates a flat file named newpo on the CWSerenade application server in the local directory defined in the CWDIRECTCP_FTP_FOLDER setting in the CWDirectCP Properties file. The delivered directory is C:\\CWSerenade\\FTP.

• Transmits the newpo flat file from the local FTP directory on the CWSerenade application server to the oms\Serenade\inbox directory on the CWCollaborate server. If a newpo flat file already exists, the system appends new information to the end of the existing file.

C03 - Send Cancel Requests FTP Application

Use this FTP application to send cancel request information from the CSF Cancel Request Table (FLCSCN) in the CWSerenade database to the canreq file in the oms\Serenade\inbox directory on the CWCollaborate server.

Enter this FTP application code in the CDC FTP ID for Cancellation Requests (H18) system control value.

FTP command:

Seq	FTP Command	Local File	Remote File	Remote Directory
001	APPEND	FLCSCN	canreq	oms\Serenade\inbox

This FTP command:

• Pulls cancel request information from the CSF Cancel Request table (FLCSCN) in the CWSerenade database.

• Creates a flat file named canreq on the CWSerenade application server in the local directory defined in the CWDIRECTCP_FTP_FOLDER setting in the CWDirectCP Properties file. The delivered directory is C:\\CWSerenade\\FTP.

• Transmits the canreq flat file from the local FTP directory on the CWSerenade application server to the oms\Serenade\inbox directory on the CWCollaborate server. If a canreq flat file already exists, the system appends new information to the end of the existing file.

C04 - Send Return Authorizations FTP Application

Use this FTP application to send return authorization information from the CSF RA Download Table (FLCSRA) in the CWSerenade database to the newra file in the oms\Serenade\inbox directory on the CWCollaborate server.

Enter this FTP application code in the CDC FTP ID for Returns Download (H56) system control value.

FTP command:

Seq	FTP Command	Local File	Remote File	Remote Directory
001	APPEND	FLCSRA	newra	oms\Serenade\inbox

This FTP command:

• Pulls return authorization information from the CSF RA Download table (FLCSRA) in the CWSerenade database.

• Creates a flat file named newra on the CWSerenade application server in the local directory defined in the CWDIRECTCP_FTP_FOLDER setting in the CWDirectCP Properties file. The delivered directory is C:\\CWSerenade\\FTP.

• Transmits the newra flat file from the local FTP directory on the CWSerenade application server to the oms\Serenade\inbox directory on the CWCollaborate server. If a newra flat file already exists, the system appends new information to the end of the existing file.

C05 - Send RA Cancels FTP Application

Use this FTP application to send return authorization cancellations from the CSF RA Cancel Table (FLCSRC) in the CWSerenade database to the canra file in the oms\Serenade\inbox directory on the CWCollaborate server.

Enter this FTP application code in the CDC FTP ID for Deleted RAs (H57) system control value.

FTP command:

Seq	FTP Command	Local File	Remote File	Remote Directory
001	APPEND	FLCSRC	canra	oms\Serenade\inbox

This FTP command:

• Pulls return authorization cancellation information from the CSF RA Cancel table (FLCSRC) in the CWSerenade database.

• Creates a flat file named canra on the CWSerenade application server in the local directory defined in the CWDIRECTCP_FTP_FOLDER setting in the CWDirectCP Properties file. The delivered directory is C:\\CWSerenade\\FTP.

• Transmits the canra flat file from the local FTP directory on the CWSerenade application server to the oms\Serenade\inbox directory on the CWCollaborate server. If a canra flat file already exists, the system appends new information to the end of the existing file.

C06 - Send Cost Changes FTP Application

Use this FTP application to send purchase order cost changes from the CSF Cost Change Table (FLCSCC) in the CWSerenade database to the pocostchg file in the oms\Serenade\inbox directory on the CWCollaborate server.

Enter this FTP application code in the CDC FTP ID for PO Cost Changes (H78) system control value.

FTP command:

Seq	FTP Command	Local File	Remote File	Remote Directory
001	APPEND	FLCSCC	pocostchg	oms\Serenade\inbox

This FTP command:

• Pulls purchase order cost change information from the CSF Cost Change table (FLCSCC) in the CWSerenade database.

• Creates a flat file named pocostchg on the CWSerenade application server in the local directory defined in the CWDIRECTCP_FTP_FOLDER setting in the CWDirectCP Properties file. The delivered directory is C:\\CWSerenade\\FTP.

• Transmits the pocostchg flat file from the local FTP directory on the CWSerenade application server to the oms\Serenade\inbox directory on the CWCollaborate server. If a pocostchg flat file already exists, the system appends new information to the end of the existing file.

C07 - Receive PO Updates FTP Application

Use this FTP application to retrieve purchase order update information from the newpoupdt file in the oms\Serenade\outbox directory on the CWCollaborate server to the CSF Status Upload Table (FLCSFS) in the CWSerenade database.

Enter this FTP application code in the CDC FTP ID for PO Updates (H19) system control value.

FTP command:

Seq	FTP Command	Local File	Remote File	Remote Directory
001	RENAME	poupdt	newpoupdt	oms\Serenade\outbox
002	GET	FLCSFS	newpoupdt	oms\Serenade\outbox
003	DELETE		newpoupdt	oms\Serenade\outbox

This FTP command:

• Looks for a file named poupdt in the oms\Serenade\outbox directory on the CWCollaborate server. If a poupdt file is found, the system renames the file to newpoupdt.

• Transmits the newpoupdt file from the oms\Serenade\outbox directory on the CWCollaborate server to the local FTP directory on the CWSerenade server defined in the CWDIRECTCP_FTP_FOLDER setting in the CWDirectCP Properties file. The delivered directory is C:\\CWSerenade\\FTP.

• Transmits the data in the newpoupdt file in the local FTP directory on the CWSerenade application server to the CSF Status Upload table (FLCSFS) in the CWSerenade database.

• Deletes the newpoupdt file from the local FTP directory on the CWSerenade application server and the oms\Serenade\outbox directory on the CWCollaborate server.

C08 - Receive RA Updates FTP Application

Use this FTP application to retrieve return authorization update information from the return file in the oms\Serenade\outbox directory on the CWCollaborate server to the CSF Return Upload Table (FLRART) in the CWSerenade database.

Enter this FTP application code in the CDC FTP ID for Return Updates (H58) system control value.

FTP command:

Seq	FTP Command	Local File	Remote File	Remote Directory
001	GET	FLRART	return	oms\Serenade\outbox
002	DELETE		return	oms\Serenade\outbox

This FTP command:

• Transmits the return file from the oms\Serenade\outbox directory on the CWCollaborate server to the local FTP directory on the CWSerenade server defined in the CWDIRECTCP_FTP_FOLDER setting in the CWDirectCP Properties file. The delivered directory is C:\\CWSerenade\\FTP.

• Transmits the data in the return file in the local FTP directory on the CWSerenade application server to the CSF Return Upload table (FLRART) in the CWSerenade database.

• Deletes the return file from the local FTP directory on the CWSerenade application server and the oms\Serenade\outbox directory on the CWCollaborate server.

C09 - Receive AP Updates FTP Application

Use this FTP application to retrieve A/P update information from the invoice file in the oms\Serenade\outbox directory on the CWCollaborate server to the A/P Invoice Upload Table (APINUP) in the CWSerenade database.

Enter this FTP application code in the CDC FTP ID for AP Invoice Upload (H77) system control value.

FTP command:

Seq	FTP Command	Local File	Remote File	Remote Directory
001	GET	APINUPTEMP	invoice	oms\Serenade\outbox
002	DELETE		invoice	oms\Serenade\outbox

This FTP command:

• Transmits the invoice file from the oms\Serenade\outbox directory on the CWCollaborate server to the local FTP directory on the CWSerenade server defined in the CWDIRECTCP_FTP_FOLDER setting in the CWDirectCP Properties file. The delivered directory is C:\\CWSerenade\\FTP.

• Transmits the data in the invoice file in the local FTP directory on the CWSerenade application server to the A/P Invoice Upload Temporary table (APINUPTEMP) in the CWSerenade database.

• Deletes the invoice file from the local FTP directory on the CWSerenade application server and the oms\Serenade\outbox directory on the CWCollaborate server.

C10 - Outbound PO Changes FTP Application

Use this FTP application to send purchase order changes from the CSF PO Download Table (FLCSPO) in the CWSerenade database to the poaddrchg file in the oms\Serendade\inbox directory on the CWCollaborate server.

Enter this FTP application code in the CDC FTP ID for Outbound PO Download Changes (H35) system control value.

FTP command:

Seq	FTP Command	Local File	Remote File	Remote Directory
001	APPEND	FLCSPO	poaddrchg	oms\Serenade\inbox

This FTP command:

• Pulls purchase order change information from the CSF PO Download table (FLCSPO) in the CWSerenade database.

• Creates a flat file named poaddrchg on the CWSerenade application server in the local directory defined in the CWDIRECTCP_FTP_FOLDER setting in the CWDirectCP Properties file. The delivered directory is C:\\CWSerenade\\FTP.

• Transmits the poaddrchg flat file from the local FTP directory on the CWSerenade application server to the oms\Serenade\inbox directory on the CWCollaborate server. If a poaddrchg flat file already exists, the system appends new information to the end of the existing file.

FTP Configuration File

CWDirectCP Properties File

Use the cwdirectcp.properties file to define the local directory on the CWSerenade application server where flat files are staged to transmit between the CWSerenade server and another server via FTP.

Location of file: This file is normally saved on the CWSerenade application server at C:\Serenade\server\conf\cwdirectcpproperties\cwdirectcp.properties, where C: is the root drive of the server.

To edit the file: You can use a text editor to edit the file, being careful not to change any of the settings except those indicated below.

If you make any changes to the CWDirectCP Properties file, you must stop and restart the Serenade service (or the application server) before the changes take effect.

Property Name	Description
CWDIRECTCP_FTP_FOLDER	The local directory on the CWSerenade application server where flat files are staged to transmit between the CWSerenade server and another server via FTP. • If you are in a Windows environment, when entering the directory path, make sure you use a double backward slash between folder names. For example, if the directory path is C:\CWSerenade\FTP, enter C:\\CWSerenade\\FTP. • If you are in a Unix environment, when entering the directory path, make sure you use a double forward slash between folder names. For example, if the directory path is C:\CWSerenade\FTP, enter C://CWSerenade//FTP. Note: If this local directory does not already exist on the CWSerenade application server, the system dynamically creates it.
CWDIRECTCP_FTP_FOLDER_ SEPARATOR	Defines the separator used in FTP commands that specify a directory on the remote server. For example, the separator \\ is compatible in a Windows environment and the separator // is compatible in a Unix environment. If this setting is blank, the default used by the system is \\.

Creating Your Own FTP Applications

Purpose: If you wish to send information between CWSerenade and another system that is currently not included in one of the Delivered FTP Applications, you must create your own FTP application.

• You can modify the delivered FTP applications to extract information from the CWSerenade database to a flat file that you can send to another system via FTP; see Delivered FTP Applications to Extract Information from the CWSerenade Database for a list of the delivered FTP applications, the information that is extracted from the CWSerenade database by these FTP applications, and how to configure these FTP applications to fit your needs.

• You can modify the delivered FTP applications to import information to the CWSerenade database from a flat file received from another system via FTP; see Delivered FTP Applications to Import Information to the CWSerenade Database for a list of the delivered FTP applications, the information that is uploaded to the CWSerenade database by these FTP applications, and how to configure these FTP applications to fit your needs.

• If the delivered FTP applications do not extract or import the information that you need, you can create a new FTP application to fit your needs; see Creating Your Own FTP Application.

Delivered FTP Applications to Extract Information from the CWSerenade Database

The following delivered FTP applications can be used to extract information from the CWSerenade database to a flat file that you can send to another system via FTP. These FTP applications are delivered to work with the CWCollaborate integration; however, you can modify them to fit your needs.

Note: If you are also using these FTP applications for the CWCollaborate integration, you must create new FTP applications and use the delivered FTP applications as a guideline on how to create them.

Delivered FTP Application	Extracted Information	Required Configuration
C01- Send Vendors FTP Application	Allows you to send vendor information from the CSF Vendor Download Table (FLCSVD) in the CWSerenade database to a flat file named FLCSVD in the FTP directory on the CWSerenade application server.	Define the information required to connect to the remote server on the Create FTP Application Screen. On the Create FTP Command Screen: • FTP Command = PUT • Local File = FLCSVD • Remote File = Enter the name of the flat file you wish to create on the remote server. • Remote directory = Enter the directory on the remote server where you wish to place the flat file containing vendor information.
C02 - Send Purchase Orders FTP Application	Allows you to send new purchase order information from the CSF PO Download Table (FLCSPO) in the CWSerenade database to a flat file named FLCSPO in the FTP directory on the CWSerenade application server.	Define the information required to connect to the remote server on the Create FTP Application Screen. On the Create FTP Command Screen: • FTP Command = APPEND • Local File = FLCSPO • Remote File = Enter the name of the flat file you wish to create on the remote server. • Remote directory = Enter the directory on the remote server where you wish to place the flat file containing purchase order information.
C03 - Send Cancel Requests FTP Application	Allows you to send purchase order cancel request information from the CSF Cancel Request Table (FLCSCN) in the CWSerenade database to a flat file named FLCSCN in the FTP directory on the CWSerenade application server.	Define the information required to connect to the remote server on the Create FTP Application Screen. On the Create FTP Command Screen: • FTP Command = APPEND • Local File = FLCSCN • Remote File = Enter the name of the flat file you wish to create on the remote server. • Remote directory = Enter the directory on the remote server where you wish to place the flat file containing cancel request information.
C04 - Send Return Authorizations FTP Application	Allows you to send return authorization information from the CSF RA Download Table (FLCSRA) in the CWSerenade database to a flat file named FLCSRA in the FTP directory on the CWSerenade application server.	Define the information required to connect to the remote server on the Create FTP Application Screen. On the Create FTP Command Screen: • FTP Command = APPEND • Local File = FLCSRA • Remote File = Enter the name of the flat file you wish to create on the remote server. • Remote directory = Enter the directory on the remote server where you wish to place the flat file containing return authorization information.
C05 - Send RA Cancels FTP Application	Allows you to send return authorization cancellations from the CSF RA Cancel Table (FLCSRC) in the CWSerenade database to a flat file named FLCSRC in the FTP directory on the CWSerenade application server.	Define the information required to connect to the remote server on the Create FTP Application Screen. On the Create FTP Command Screen: • FTP Command = APPEND • Local File = FLCSRC • Remote File = Enter the name of the flat file you wish to create on the remote server. • Remote directory = Enter the directory on the remote server where you wish to place the flat file containing return authorization cancellations.
C06 - Send Cost Changes FTP Application	Allows you to send purchase order cost changes from the CSF Cost Change Table (FLCSCC) in the CWSerenade database to a flat file named FLCSCC in the FTP directory on the CWSerenade application server.	Define the information required to connect to the remote server on the Create FTP Application Screen. On the Create FTP Command Screen: • FTP Command = APPEND • Local File = FLCSCC • Remote File = Enter the name of the flat file you wish to create on the remote server. • Remote directory = Enter the directory on the remote server where you wish to place the flat file containing purchase order cost changes.
C10 - Outbound PO Changes FTP Application	Allows you to send purchase order changes from the CSF PO Download Table (FLCSPO) in the CWSerenade database to a flat file named FLCSPO in the FTP directory on the CWSerenade application server.	Define the information required to connect to the remote server on the Create FTP Application Screen. On the Create FTP Command Screen: • FTP Command = APPEND • Local File = FLCSPO • Remote File = Enter the name of the flat file you wish to create on the remote server. • Remote directory = Enter the directory on the remote server where you wish to place the flat file containing purchase order changes.

Delivered FTP Applications to Import Information to the CWSerenade Database

The following delivered FTP applications can be used to import information to the CWSerenade database from a flat file received from another system via FTP. These FTP applications are delivered to work with the CWCollaborate integration; however, you can modify them to fit your needs.

Note: If you are also using these FTP applications for the CWCollaborate integration, you must create new FTP applications and use the delivered FTP applications as a guideline on how to create them.

Delivered FTP Application	Extracted Information	Required Configuration
C07 - Receive PO Updates FTP Application	Allows you to retrieve purchase order update information from a flat file named FLCSFS in the FTP directory on the CWSerenade application server to the CSF Status Upload Table (FLCSFS) in the CWSerenade database.	Define the information required to connect to the remote server on the Create FTP Application Screen. On the Create FTP Command Screen: For the first FTP command: • FTP Command = RENAME • Local File = Enter the name of the flat file on the remote server. • Remote File = Enter the new name you wish to assign to the flat file on the remote server prior to retrieving it via FTP. • Remote directory = Enter the directory on the remote server where the flat file exists. For the second FTP command: • FTP Command = GET • Local File = FLCSFS • Remote File = Enter the new name you have assigned to the flat file on the remote server prior to retrieving it via FTP. • Remote directory = Enter the directory on the remote server where the flat file exists. For the third FTP command: • FTP Command = DELETE • Remote File = Enter the new name you have assigned to the flat file on the remote server prior to retrieving it via FTP. This is the name of the flat file you wish to delete on the remote server. • Remote directory = Enter the directory on the remote server where the flat file exists.
C08 - Receive RA Updates FTP Application	Allows you to retrieve return authorization update information from a flat file named FLRART in the FTP directory on the CWSerenade application server to the CSF Return Upload Table (FLRART) in the CWSerenade database.	Define the information required to connect to the remote server on the Create FTP Application Screen. On the Create FTP Command Screen: For the first FTP command: • FTP Command = GET • Local File = FLRART • Remote File = Enter the name of the flat file on the remote server you wish to retrieve via FTP. • Remote directory = Enter the directory on the remote server where the flat file exists. For the second FTP command: • FTP Command = DELETE • Remote File = Enter the name of the flat file on the remote server you wish to delete once it has been retrieved via FTP. • Remote directory = Enter the directory on the remote server where the flat file exists.
C09 - Receive AP Updates FTP Application	Allows you to retrieve A/P invoice information from a flat file named APINUP in the FTP directory on the CWSerenade application server to the A/P Invoice Upload Table (APINUP) in the CWSerenade database.	Define the information required to connect to the remote server on the Create FTP Application Screen. On the Create FTP Command Screen: For the first FTP command: • FTP Command = GET • Local File = APINUPTEMP • Remote File = Enter the name of the flat file on the remote server you wish to retrieve via FTP. • Remote directory = Enter the directory on the remote server where the flat file exists. For the second FTP command: • FTP Command = DELETE • Remote File = Enter the name of the flat file on the remote server you wish to delete once it has been retrieved via FTP. • Remote directory = Enter the directory on the remote server where the flat file exists.

Creating Your Own FTP Application

If the Delivered FTP Applications do not extract or import the information that you require, you can create a new FTP application to fit your needs.

• Extracting Information from the CWSerenade Database via FTP

• Importing Information to the CWSerenade Database via FTP

Extracting Information from the CWSerenade Database via FTP

Use the following steps to create an FTP application that extracts information from a table in the CWSerenade database to send to a remote system via FTP.

1.

Use the SQL Server Data Transformation Services (DTS) export wizard, or a similar tool, to extract information from a table in the CWSerenade database to a flat file in the local FTP directory on the CWSerenade application server. Important: In order for the FTP application that you create to work, you must first extract the information from the CWSerenade database and place it in a flat file in the FTP directory specified in the CWDIRECTCP_FTP_FOLDER setting in the CWDirectCP Properties File. This step is not part of the CWSerenade FTP process. Contact your MICROS representative if you would like assistance in extracting information from the CWSerenade database to a flat file.

2.

Once you have successfully created a flat file that contains the information that has been extracted from the CWSerenade database, create an FTP application to move the flat file from the local FTP directory on the CWSerenade application server to a specified directory on the remote server. • On the Create FTP Application Screen, create an FTP application code, making sure to define the IP address or name of the remote server and the user ID and password used to connect to the FTP site on the remote server. • On the Create FTP Command Screen, create the FTP command used to send the flat file from the local FTP directory on the CWSerenade application server to a specified directory on the remote server. Example: The following command moves the FLCSVD flat file from the local FTP directory on the CWSerenade application server to the vendor flat file in the oms\Serenade\inbox directory on the remote server: • FTP command = PUT • Local file = FLCSVD • Remote file = vendor • Remote directory = oms\Serenade\inbox

Importing Information to the CWSerenade Database via FTP

Use the following steps to create an FTP application that retrieves a file from a remote system via FTP and imports the file to the CWSerenade database.

1.

Create an FTP application to retrieve a file from a specified directory on the remote server to the local FTP directory on the CWSerenade application server. • On the Create FTP Application Screen, create an FTP application code, making sure to define the IP address or name of the remote server and the user ID and password used to connect to the FTP site on the remote server. • On the Create FTP Command Screen, create the FTP command used to retrieve the file from the specified directory on the remote server to the local FTP directory on the CWSerenade application server. Example: The following command retrieves the newpoupdt flat file from the oms\Serenade\outbox directory on the remote server to the FLCSFS flat file in the local FTP directory on the CWSerenade application server: • FTP command = GET • Local file = FLCSFS • Remote file = newpoupdt • Remote directory = oms\Serenade\outbox

2.

Use the SQL Server Data Transformation Services (DTS) import wizard, or a similar tool, to import information from a flat file in the local FTP directory on the CWSerenade application server to a specified table in the CWSerenade database. Contact your MICROS representative if you would like assistance in importing information from a flat file to a table in the CWSerenade database.

FTP Troubleshooting

If you are having trouble sending messages between CWSerenade and a remote server via FTP, you can use the following steps to troubleshoot where the transmission error occurred.

Errors in FTP Log?

Use the Display FTP Log Screen to check the FTP log to verify that an error did not occur during transmission. The system updates this log each time the FTP commands for an FTP application are processed. This log indicates:

• Whether a connection was successfully established with the remote server.

• Whether the file was moved successfully between the two specified locations.

• Whether the FTP transfer completed successfully.

Connection Not Established?

If the FTP log indicates that a connection with the remote server was not established successfully:

• Check the connection settings defined for the FTP application on the Change FTP Application screen; see Create FTP Application Screen for field descriptions.

• Verify that the IP address or server name to connect to the remote server is correct.

• Verify that the user name and password is a valid user account for the FTP site in Internet Information Services (IIS) Manager on the remote server.

• Check the FTP configuration settings in Internet Information Services (IIS) Manager on the remote server.

• Verify the FTP user account and password you defined for the FTP application is a valid user account for the FTP site.

• Verify the properties defined for the FTP site, such as the FTP site IP address and the home directory defined for the FTP site.

FTP File Transmission Unsuccessful?

If the FTP log indicates that the file was not transmitted successfully:

• Check the FTP commands defined for the FTP application on the Work with FTP Commands Screen. Verify:

• The FTP command is applicable for the type of transmission. For a transmission from the local FTP directory on the CWSerenade application server to the remote server, the FTP command should be PUT or APPEND. For a transmission from the remote server to the local FTP directory on the CWSerenade application server, the FTP command should be GET.

• Verify that the remote directory is correct. Verify that the name of each folder in the directory is correct. Check the spelling of each folder name.

• Verify that the name of the remote file and local file is correct. Check the spelling of each file name.

• Check the CWDIRECTCP_FTP_FOLDER setting in the CWDirectCP Properties File. This is the local directory on the CWSerenade application server where flat files are staged to transmit between the CWSerenade server and another server via FTP.

• Check the CWDIRECTCP_FTP_FOLDER_SEPARATOR setting in the CWDirectCP Properties File. If you are in a Windows environment, the setting should be \\ or blank. If you are in a Unix environment, the setting should be //.

FTP Transmission Successful?

If the FTP log indicates that the file was transmitted successfully, but you do not see the expected results:

FTP Transmission from the CWSerenade Application Server to the Remote Server

Determine if the file exists in the specified directory on the remote server. If the file does exist, then you know that the FTP transmission was successful.

If the file does not exist, it could be that a process on the remote server is monitoring the directory for new files to process and has already processed the file.

For example, for the CWCollaborate integration, CWCollaborate monitors the directory where new files from CWSerenade are received and when a new file is found, CWCollaborate retrieves the file and processes it. You can review the CWCollaborate logs and reports to determine if an error occurred during processing. See the CWCollaborate Configuration and Reference Guide for more information.

FTP Transmission from the Remote Server to the CWSerenade Application Server

Check the Date modified field for the file in the local FTP directory on the CWSerenade application server to determine the last time the file was updated. If the date and time are correct, then you know that the FTP transmission was successful.

Verify that the contents of the file are correct and that the format of the file is correct. If the file contains invalid data, or if the format of the file is not correct (for example, data in the file may require leading zeros), then the system may not be able to import the data into the correct table in the CWSerenade database.

For the CWCollaborate integration, check the CWCollaborate Interface Tables to determine if the information has successfully been uploaded to the CWSerenade database. If information exists in the table, but you cannot see the information in CWSerenade, check the status of the CWCollaborate async job. This job must be active to move data from the CWCollaborate interface table to the correct CWSerenade table.

CDC Async Job Not Processing Records?

The CDC async job processes records in the CWCollaborate Interface Tables. If the records in these tables are not being processed, stop and restart the CDC async job.

If the CDC async job does not end when you stop it: Occasionally, the CDC async job will not stop when you end it; it will remain in an ENDING status. If this happens, it may be because there are multiple IX_CDC jobs running in the same CWSerenade environment, for example, if the CDC async job was manually changed to INACTIVE and then started again, or if the CDC async ended hard because the server was restarted while the job was running.

To eliminate multiple IX_CDC jobs, use the following steps:

1. Manually change the status of the CDC async job to INACTIVE.

2. Verify that the IX_CDC job is not active on the Job Management (My Jobs) screen. Make sure to check across all users and job queues.

3. If you find an IX_CDC job that is in a RUN or MSG status, select End for the job to end it.

4. Use the Purge Active Procedures Across Users (MACX) menu option to check for active procedures related to CWCollaborate processing. If any active procedures related to CWCollaborate processing exist, delete them.

5. Start the CDC async. Once the CDC async updates to an ACTIVE status, stop and restart the CDC async again to verify that it is working correctly.

See Working with Drop Ship Background Jobs (WPBJ) for more information on working with the CDC async job.